Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
You guessed it – the internet is your friend. A good place to start looking for Telegram channels is Reddit. This is one of the biggest sites on the internet, with millions of communities, including those from Telegram.Then, you can search one of the many dedicated websites for Telegram channel searching. One of them is telegram-group.com. This website has many categories and a really simple user interface. Another great site is telegram channels.me. It has even more channels than the previous one, and an even better user experience.These are just some of the many available websites. You can look them up online if you’re not satisfied with these two. All of these sites list only public channels. If you want to join a private channel, you’ll have to ask one of its members to invite you.
Telegram auto-delete message, expiring invites, and more
elegram is updating its messaging app with options for auto-deleting messages, expiring invite links, and new unlimited groups, the company shared in a blog post. Much like Signal, Telegram received a burst of new users in the confusion over WhatsApp’s privacy policy and now the company is adopting features that were already part of its competitors’ apps, features which offer more security and privacy. Auto-deleting messages were already possible in Telegram’s encrypted Secret Chats, but this new update for iOS and Android adds the option to make messages disappear in any kind of chat. Auto-delete can be enabled inside of chats, and set to delete either 24 hours or seven days after messages are sent. Auto-delete won’t remove every message though; if a message was sent before the feature was turned on, it’ll stick around. Telegram’s competitors have had similar features: WhatsApp introduced a feature in 2020 and Signal has had disappearing messages since at least 2016.
